home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / cashclose.sql < prev    next >
Text File  |  2000-05-12  |  2KB  |  40 lines
  1. /* RCSVER $Id: cashclose.sql,v 1.1 1999-12-02 16:50:33-06 randy CURRENT $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:        cashclose.sql
  6. * Date:        08/18/1999
  7. * memo:        Randy Wood
  8. * Description:    Create the cashclose table. This table contains
  9. *        data from a closed probe/moneyroom match.
  10. * Changes:
  11. ************************************************************************* */
  12. CREATE TABLE cashclose
  13. (
  14.     prpend_indx        NUMBER(38),    /* Number of probe from prpend */
  15.     subbatch_seq        NUMBER(38),    /* Number of subbatch */
  16.     farebox_glid        NUMBER(38),    /* farebox number */
  17.     cashbox_glid        NUMBER(38),    /* cashbox number */
  18.     cb_sernum        VARCHAR2(20),    /* cashbox ID */
  19.     cbinsert_seq        NUMBER(38),    /* number from cbinsert table */
  20.     cbremov_seq         NUMBER(38),    /* number from cbremov table */
  21.     cbinsert_date        DATE,        /* date of cashbox insert */
  22.     cbremov_date        DATE,        /* date of cashbox removal */
  23.     probe_date        DATE,        /* date of probe */
  24.     last_curstate        NUMBER(38),    /* last curstate prior to removal */
  25.     revenue_service_seq    NUMBER(38),    /* revenue sequence number from curstate */
  26.     cbcount_date        DATE,        /* Date of count in money room */
  27.     probe_coin_totals     NUMBER(36,2),
  28.     probe_bill_totals    NUMBER(36,2),
  29.     probe_amt        NUMBER(36,2),    /* Cash amount from probe */
  30.     count_coin_totals     NUMBER(36,2),
  31.     count_bill_totals    NUMBER(36,2),
  32.     count_amt        NUMBER(36,2),    /* Cash amount from moneyroom */
  33.     clbatch_num        NUMBER(38),    /* Close batch number */
  34.     excp_num        NUMBER(38),    /* Exception number */
  35.     conversion_num        NUMBER(38),    /* probe convert number */
  36.     comments        VARCHAR2(500),    /* User comments */
  37.     revenue_service_time    DATE,        /* Cashbox insert time */
  38.     CONSTRAINT pk_cashclose PRIMARY KEY (prpend_indx, subbatch_seq)
  39. );
  40.